﻿<%@ Page Title="Virtual Flight Info." Language="C#" Culture="auto" UICulture="auto" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="PlanVirtualFltInfo.aspx.cs" Inherits="IFD2.PlanVirtualFltInfo" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <form id="form1" runat="server" role="form" class="form-inline" defaultbutton="lbtnQuery">
    <div class="container-fluid body-content" style="width:100%;">

    <div class="row">
        <div class="col-sm-2 well well-sm">
            <h5><asp:Literal ID="litTitle" runat="server" meta:resourcekey="tipPageTitle"></asp:Literal></h5>
            <div class="form-group">
                <asp:Label ID="Label1" runat="server" Text="Flight:" meta:resourcekey="Flight"></asp:Label>
                <asp:Label ID="lblAirline" runat="server" Font-Bold="true"></asp:Label>
                <asp:Label ID="lblFltNo" runat="server"></asp:Label><br />
                <asp:Label ID="Label4" runat="server" Text="Plan ID:" meta:resourcekey="PlanID"></asp:Label>
                <asp:Label ID="lblPlan" runat="server" Font-Bold="true"></asp:Label><br />
            </div>
            <br class="hidden-xs"/><br class="hidden-xs"/>
            <asp:LinkButton ID="lbtnQuery" runat="server" CssClass="form-control input-sm btn-primary text-center" Width="100%" ToolTip="" meta:resourcekey="tipQuery" OnClick="lbtnQuery_Click"> <span class="glyphicon glyphicon-search" style="font-size:large;"></span></asp:LinkButton>
            <p></p><%--没有此行(或&nbsp;)，上面的按钮在手机模式(xs)下，只有上半部可以点击！--%>
        </div>

        <div class="col-sm-10 well well-sm">
            <div class="panel">
                <div class="panel-heading btn-primary">
                    <h6 class="panel-title" id="section-2"><asp:Literal ID="Literal1" runat="server" meta:resourcekey="FundamentalInfo">Fundamental Info:</asp:Literal></h6>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" 
                            DataKeyNames="airline,flt_no,id" DataSourceID="sqlBase"  style="min-width:500px;width:100%;" class="table-hover">
                            <RowStyle BackColor="#EFF3FB" />
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <EditRowStyle BackColor="#2461BF" />
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:BoundField DataField="plan_status" HeaderText="plan_status" SortExpression="plan_status"  meta:resourcekey="plan_status" />
                                <asp:BoundField DataField="week_mask" HeaderText="week_mask" SortExpression="week_mask"  meta:resourcekey="week_mask" />
                                <asp:BoundField DataField="date_from" HeaderText="date_from" SortExpression="date_from"  meta:resourcekey="date_from" />
                                <asp:BoundField DataField="date_to" HeaderText="date_to" SortExpression="date_to"  meta:resourcekey="date_to" />
                                <asp:BoundField DataField="initial_status" HeaderText="initial_status" SortExpression="initial_status"  meta:resourcekey="initial_status" />
                                <asp:BoundField DataField="tax_type" HeaderText="tax_type" SortExpression="tax_type"  meta:resourcekey="tax_type" />
                            </Columns>
                        </asp:GridView>
                    </div>
                </div>
                <asp:SqlDataSource ID="sqlBase" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                    SelectCommand="bll_plan_get_virtual_flts_info" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lblAirline" Name="airline" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="lblFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="lblPlan" Name="plan_id" PropertyName="Text" Type="String" />
                        <asp:SessionParameter Name="user_airline" SessionField="AIRLINE" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </div>

            <div class="panel">
                <div class="panel-heading btn-primary">
                    <h6 class="panel-title" id="section-3"><asp:Literal ID="Literal2" runat="server" meta:resourcekey="FlightTrip">Flight Trip:</asp:Literal></h6>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <asp:GridView ID="GridView2" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" 
                            DataKeyNames="airline,flt_no,id,stop_sn" DataSourceID="sqlTrip"  style="min-width:500px;width:100%;">
                            <RowStyle BackColor="#EFF3FB" />
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <EditRowStyle BackColor="#2461BF" />
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:BoundField DataField="stop_sn" HeaderText="stop_sn" ReadOnly="True" SortExpression="stop_sn"  meta:resourcekey="stop_sn" />
                                <asp:BoundField DataField="city" HeaderText="city" SortExpression="city"  meta:resourcekey="city" />
                                <asp:BoundField DataField="airport" HeaderText="airport" SortExpression="airport"  meta:resourcekey="airport" />
                                <asp:BoundField DataField="terminal" HeaderText="terminal" SortExpression="terminal"  meta:resourcekey="terminal" />
                                <asp:BoundField DataField="dep_date_diff" HeaderText="dep_date_diff" SortExpression="dep_date_diff"  meta:resourcekey="dep_date_diff" />
                                <asp:BoundField DataField="dep_time" HeaderText="dep_time" SortExpression="dep_time"  meta:resourcekey="dep_time" />
                                <asp:BoundField DataField="arr_date_diff" HeaderText="arr_date_diff" SortExpression="arr_date_diff"  meta:resourcekey="arr_date_diff" />
                                <asp:BoundField DataField="arr_time" HeaderText="arr_time" SortExpression="arr_time"  meta:resourcekey="arr_time" />
                            </Columns>
                        </asp:GridView>
                    </div>
                </div>
                <asp:SqlDataSource ID="sqlTrip" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>" SelectCommand="bll_plan_get_virtual_flt_route" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lblAirline" Name="airline" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="lblFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="lblPlan" Name="plan_id" PropertyName="Text" Type="String" />
                        <asp:SessionParameter Name="user_airline" SessionField="AIRLINE" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </div>

            <div class="panel">
                <div class="panel-heading btn-primary">
                    <h6 class="panel-title" id="section-4"><asp:Literal ID="Literal3" runat="server" meta:resourcekey="SharedClasses">Shared Classes:</asp:Literal></h6>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <asp:GridView ID="GridView3" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" 
                            DataSourceID="sqlClasses"  style="min-width:800px;width:100%;">
                            <RowStyle BackColor="#EFF3FB" />
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <EditRowStyle BackColor="#2461BF" />
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:BoundField DataField="seg_sn" HeaderText="seg_sn" SortExpression="seg_sn"  meta:resourcekey="seg_sn" />
                                <asp:BoundField DataField="ori_airport" HeaderText="ori_airport" SortExpression="ori_airport"  meta:resourcekey="ori_airport" />
                                <asp:BoundField DataField="des_airport" HeaderText="des_airport" SortExpression="des_airport"  meta:resourcekey="des_airport" />
                                <asp:BoundField DataField="cabin" HeaderText="cabin" SortExpression="cabin"  meta:resourcekey="cabin" />
                                <asp:BoundField DataField="class" HeaderText="class" SortExpression="class"  meta:resourcekey="class" />
                                <asp:BoundField DataField="status" HeaderText="status" SortExpression="status"  meta:resourcekey="status" />
                                <asp:BoundField DataField="max_opn" HeaderText="max_opn" SortExpression="max_opn"  meta:resourcekey="max_opn" />
                                <asp:BoundField DataField="total_avail" HeaderText="total_avail" SortExpression="total_avail"  meta:resourcekey="total_avail" />
                                <asp:CheckBoxField DataField="nested" HeaderText="nested" SortExpression="nested" meta:resourcekey="nested" />
                            </Columns>
                        </asp:GridView>
                    </div>
                </div>
                <asp:SqlDataSource ID="sqlClasses" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>" SelectCommand="bll_plan_get_virtual_flt_classes" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lblAirline" Name="airline" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="lblFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="lblPlan" Name="plan_id" PropertyName="Text" Type="String" />
                        <asp:SessionParameter Name="user_airline" SessionField="AIRLINE" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </div>

        </div>
    </div>

    </div></form>
</asp:Content>
